/*Retrieve all of your customers' names,account numbers, and addresses (street and zip 
code only), sorted by account number*/
Select customer_id as "Account Number",customer_name,last_name,address from customer order by customer_id; 



/*Retrieve all of the videos rented in the last 30 days and sort in chronological rental date 
order.*/
Select order.order_date,movie.movie_title,movie.genre,movie.discount
from order,movie 
where order.order_date BETWEEN ADD_MONTHS(sysdate,-1) AND CURRENT_DATE
order by order_date;


/*Produce a list of your distributors and all their information sorted in 
order by company name.*/

Select * from distributor order by distributor_name; 

/*Update a customer name to change their maiden name to a married name
. You can choose which row to update.Make sure that you use the primary key column in your 
WHERE clause to affect only a specific row.*/ 

update customer set NAME='MR. ELVIS' where CUSTOMER_ID=1; 

/*Delete a customer from the database. You can choose which row to delete.
Make sure that you use the primary key column in your WHERE clause to affect only a specific row.*/

delete from customer where customer.customer_id=5;